<?php
include "db.php";
$club=$_REQUEST['club'];
echo "<input type='hidden' name='clubs' value='$club'>";
$sql="SELECT * FROM st_club WHERE club_number ='$club'";
$result = mysql_query($sql) or die( mysql_error());
while ($fila = mysql_fetch_assoc($result)) {
echo "<table>
		  <tr><td><b>".$fila['club_name']."</b>-Club #: ".$fila['club_number'].",Dist #: ".$fila['district']." Area: ".$fila['division'].$fila['area'].", Est: ".$fila['charter_date']."</td></tr>
		  <tr><td>".$fila['address1']."</td></tr>
		  <tr><td>".$fila['address2'].", ".$fila['club_name'].", ".$fila['estado_id'].", ".$fila['cp'].",".$fila['country']."</td></tr>
		  <tr><td>".$fila['phone']."</td></tr>
		  <tr><td>Meeting Time: ".$fila['meeting_time'].", ".$fila['meeting_day']."</td></tr>
		  <tr><td>Club Status".$fila['club_status']."</td></tr>";
}
echo " </table>";
?>
<center>
<input type='submit' value='Asignar Club'>
</center>